﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ProgNetComponents.Data;

namespace MiniKsiegowosc.DbUpdate
{
    public class UpdateVatZGroups : DBUpdateProc
    {
        public UpdateVatZGroups()
        {
            this.ForceUpdate = false;
            this.TableName = "STP_GRUPY_VATZ";
            this.KeyKolumns = new string[]{
                "STP_GRVATZ_KOD"
            };
            this.Parameters.Add(new ObjectKeyValuePairWithType("STP_GRVATZ_KOD"));
            this.Parameters.Add(new ObjectKeyValuePairWithType("STP_GRVATZ_NAZWA"));
        }

        private void InitValues()
        {
            this.AddRow("BRAK", "Bez wpisu");
            this.AddRow("NIEPO", "Nie podlegające VAT");
            this.AddRow("BEZPR", "Bez prawa do odliczenia");
            this.AddRow("VPAL", "VAT za paliwo");

            this.AddRow("OPOD", "Opodatkowane");
            this.AddRow("OP_ZW", "Opodatkowane i zwolnione");
        }
        public override bool Execute()
        {
            InitValues();
            return base.Execute();
        }
    }
}
